   
create external table jms_dm.dm_ops_xyf_reverse_cancel_hi     (
   date_time         string comment '分区',
   pick_network_code string comment '取件网点',
   pick_network_name string comment '取件网点name',
   proxy_area_code   string comment '取件代理区',
   proxy_area_name   string comment '取件代理区code',
   pick_num          int    comment '已取件',
   cancel_num        int    comment '已取消',
   wait_pick_num     int    comment '待取件',
   bill_num          int    comment '单量'
) COMMENT '逍遥峰逆向取消率机器人'
PARTITIONED BY (dt STRING COMMENT '')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_ops_xyf_reverse_cancel_hi'
TBLPROPERTIES (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);
